Main
Andrés Felipe Insuasty Ch.
I have focused on automating process and reports to take key decisions using R. Data analyst learning to be a data scientist. On my blog, I explain some of my work2
Experience
Campaigns coordinator - Data Analytics
Banco Agrario de Colombia
Bogotá, Colombia
Current - 2020
- Creator of an internal R package to manage sales campaigns in the bank.
- Automation of daily, weekly and monthly campaigns: Operational time reduced: 80 hours monthly
- Client assignment to salesforce using R package for mathematical modelling: Precission of assigment on 100% , operation time reduced: 4 hours monthly.
- Use of git to manage control version in the package among the team.
- readr, readxl, dplyr, DBI, Rmarkdown+blastula, tidyverse, tidytext, ompr, sql
Business Analyst
Ajover S.A.S
Bogotá, Colombia
2020 - 2017
- Implementation of a Master Planning optimization model.
- I Developed 12 automatic reports using R
- Tunning ETL process trought SQL.
- openxlsx, DBI, tidyverse, lubridate, stringr, ggplot2, Rmarkdown, mailR, sql
Process Analyst
Carvajal Tecnologia y Servicios
Cali, Colombia
2017 - 2015
- Led 3 Analytics projects using QlickView as a BI tool: Vendor Analytics, Daily Cash Flow and Cash flow forecasting
- openxlsx, tidyverse, ggplot2, plotly
Project Engineer
DecisionWare
Madrid, Spain
2015 - 2014
- Support (Technical and commercial) on projects focused on improving and optimizing business processes using Operations Research, Mathematical Modelling.
- Excel, Power Point
Education
MSc. Statistics and Operations Research
Universitat Politècnica de Catalunya
Barcelona, Spain
2015 - 2013
- Focused on Operations Reasearch
- R, SQL, AMPL
B.S., Industrial Enginner
Universidad Icesi
Cali, Colombia
2012 - 2007
- Excel, Power Point, AMPL,